﻿CREATE PROCEDURE [dbo].[Hogar_Actividad_ObtenerTalleres]
AS
BEGIN
	SELECT [ActividadId]
      ,[Nombre]
      ,[TipoActividadId]
      ,CASE WHEN [Activa] = 1 THEN 1 ELSE 0 END AS [Activa]
      ,[ResponsableId]
      ,[FechaBaja]
	FROM [dbo].[Actividad] WITH (NOLOCK)
	WHERE [Activa] = 1 AND [TipoActividadId] = 3
END
